Complete Linux

home *** CD-ROM | disk | FTP | other *** search

/ Complete Linux / Complete Linux.iso / docs / apps / database / postgres / postgre2.z / postgre2 / doc / implementation / planner / table5.2 < prev next >

Wrap

Text File | 1992-08-27 | 6.8 KB | 755 lines

sungremlinfile 0 452.00 504.00 VECTOR 452.00 504.00 452.00 56.00 * 5 0 0 VECTOR 260.00 504.00 260.00 56.00 * 5 0 0 VECTOR 84.00 504.00 84.00 56.00 * 5 0 0 VECTOR 8.00 504.00 8.00 56.00 500.00 56.00 500.00 504.00 8.00 504.00 * 5 0 0 TOPLEFT 24.00 496.00 24.00 487.00 46.00 487.00 69.00 487.00 * 1 1 7 storage CENTCENT 44.00 476.00 15.00 472.00 44.00 472.00 73.00 472.00 * 1 1 9 structure VECTOR 8.00 464.00 500.00 464.00 * 5 0 0 VECTOR 8.00 256.00 500.00 256.00 * 5 0 0 CENTCENT 476.00 476.00 463.00 472.00 476.00 472.00 489.00 472.00 * 1 1 5 diff. CENTCENT 472.00 488.00 466.00 484.00 472.00 484.00 479.00 484.00 * 1 1 1 % CENTCENT 180.00 484.00 142.00 480.00 180.00 480.00 218.00 480.00 * 1 1 8 POSTGRES CENTCENT 364.00 484.00 337.00 480.00 364.00 480.00 391.00 480.00 * 1 1 6 INGRES CENTCENT 176.00 452.00 146.00 448.00 176.00 448.00 207.00 448.00 * 1 1 9 MS - dept VECTOR 152.00 440.00 136.00 424.00 * 5 0 0 CENTCENT 136.00 416.00 102.00 412.00 136.00 412.00 171.00 412.00 * 1 1 10 sort dname VECTOR 132.00 404.00 132.00 392.00 * 5 0 0 CENTCENT 132.00 384.00 101.00 380.00 132.00 380.00 163.00 380.00 * 1 1 10 MS - floor CENTCENT 112.00 348.00 100.00 344.00 112.00 344.00 125.00 344.00 * 1 1 4 sort CENTCENT 112.00 336.00 98.00 332.00 112.00 332.00 127.00 332.00 * 1 1 5 floor VECTOR 116.00 376.00 112.00 356.00 * 5 0 0 VECTOR 112.00 324.00 112.00 312.00 * 5 0 0 CENTCENT 112.00 304.00 99.00 300.00 112.00 300.00 126.00 300.00 * 1 1 4 scan CENTCENT 116.00 292.00 90.00 288.00 116.00 288.00 143.00 288.00 * 1 1 5 WATER CENTCENT 220.00 416.00 192.00 412.00 220.00 412.00 249.00 412.00 * 1 1 9 sort dept VECTOR 200.00 440.00 216.00 424.00 * 5 0 0 VECTOR 220.00 404.00 220.00 392.00 * 5 0 0 CENTCENT 220.00 384.00 190.00 380.00 220.00 380.00 251.00 380.00 * 1 1 8 scan EMP VECTOR 164.00 376.00 172.00 352.00 * 5 0 0 CENTCENT 176.00 348.00 164.00 344.00 176.00 344.00 189.00 344.00 * 1 1 4 sort CENTCENT 176.00 336.00 162.00 332.00 176.00 332.00 191.00 332.00 * 1 1 5 floor VECTOR 176.00 324.00 176.00 312.00 * 5 0 0 CENTCENT 176.00 304.00 163.00 300.00 176.00 300.00 190.00 300.00 * 1 1 4 scan CENTCENT 176.00 292.00 157.00 288.00 176.00 288.00 195.00 288.00 * 1 1 4 DEPT VECTOR 152.00 232.00 132.00 212.00 * 5 0 0 CENTCENT 128.00 152.00 119.00 148.00 128.00 148.00 138.00 148.00 * 1 1 2 NL CENTCENT 120.00 124.00 107.00 120.00 120.00 120.00 134.00 120.00 * 1 1 4 scan VECTOR 200.00 232.00 220.00 212.00 * 5 0 0 VECTOR 224.00 192.00 224.00 176.00 * 5 0 0 VECTOR 124.00 144.00 116.00 128.00 * 5 0 0 CENTCENT 196.00 124.00 166.00 120.00 196.00 120.00 226.00 120.00 * 1 1 9 indexscan VECTOR 140.00 144.00 192.00 132.00 * 5 0 0 VECTOR 124.00 196.00 124.00 160.00 * 5 0 0 CENTCENT 176.00 240.00 145.00 236.00 176.00 236.00 207.00 236.00 * 1 1 10 MS - floor CENTCENT 44.00 388.00 37.00 384.00 44.00 384.00 52.00 384.00 * 1 1 2 no CENTCENT 44.00 372.00 23.00 368.00 44.00 368.00 65.00 368.00 * 1 1 7 indices CENTCENT 44.00 404.00 34.00 400.00 44.00 400.00 54.00 400.00 * 3 1 3 (1) CENTCENT 364.00 452.00 331.00 448.00 364.00 448.00 398.00 448.00 * 1 1 11 Join - dept CENTCENT 312.00 416.00 278.00 412.00 312.00 412.00 346.00 412.00 * 1 1 12 Join - floor VECTOR 336.00 444.00 308.00 424.00 * 5 0 0 CENTCENT 292.00 384.00 280.00 380.00 292.00 380.00 305.00 380.00 * 1 1 4 sort CENTCENT 296.00 372.00 276.00 368.00 296.00 368.00 316.00 368.00 * 1 1 5 dname VECTOR 300.00 408.00 292.00 392.00 * 5 0 0 CENTCENT 344.00 384.00 332.00 380.00 344.00 380.00 357.00 380.00 * 1 1 4 sort CENTCENT 344.00 372.00 330.00 368.00 344.00 368.00 359.00 368.00 * 1 1 5 floor VECTOR 336.00 408.00 344.00 392.00 * 5 0 0 VECTOR 292.00 360.00 292.00 348.00 * 5 0 0 CENTCENT 292.00 340.00 279.00 336.00 292.00 336.00 306.00 336.00 * 1 1 4 scan CENTCENT 296.00 328.00 277.00 324.00 296.00 324.00 315.00 324.00 * 1 1 4 DEPT VECTOR 348.00 360.00 348.00 348.00 * 5 0 0 CENTCENT 348.00 340.00 335.00 336.00 348.00 336.00 362.00 336.00 * 1 1 4 scan CENTCENT 348.00 328.00 322.00 324.00 348.00 324.00 375.00 324.00 * 1 1 5 WATER CENTCENT 404.00 416.00 376.00 412.00 404.00 412.00 433.00 412.00 * 1 1 9 sort dept VECTOR 388.00 444.00 404.00 424.00 * 5 0 0 VECTOR 408.00 408.00 408.00 392.00 * 5 0 0 CENTCENT 408.00 384.00 395.00 380.00 408.00 380.00 422.00 380.00 * 1 1 4 scan CENTCENT 408.00 372.00 393.00 368.00 408.00 368.00 423.00 368.00 * 1 1 3 EMP CENTCENT 476.00 376.00 464.00 372.00 476.00 372.00 489.00 372.00 * 1 1 4 13.8 CENTCENT 128.00 204.00 94.00 200.00 128.00 200.00 163.00 200.00 * 1 1 10 sort dname CENTCENT 120.00 112.00 94.00 108.00 120.00 108.00 147.00 108.00 * 1 1 5 WATER CENTCENT 196.00 112.00 177.00 108.00 196.00 108.00 215.00 108.00 * 1 1 4 DEPT CENTCENT 196.00 100.00 177.00 96.00 196.00 96.00 216.00 96.00 * 1 1 7 (floor) CENTCENT 224.00 204.00 196.00 200.00 224.00 200.00 253.00 200.00 * 1 1 9 sort dept CENTCENT 224.00 164.00 190.00 160.00 224.00 160.00 259.00 160.00 * 1 1 9 scan DEPT CENTCENT 476.00 144.00 464.00 140.00 476.00 140.00 489.00 140.00 * 1 1 4 12.5 CENTCENT 372.00 240.00 339.00 236.00 372.00 236.00 406.00 236.00 * 1 1 11 Join - dept CENTCENT 320.00 204.00 286.00 200.00 320.00 200.00 354.00 200.00 * 1 1 12 Join - floor VECTOR 344.00 228.00 320.00 212.00 * 5 0 0 CENTCENT 296.00 168.00 284.00 164.00 296.00 164.00 309.00 164.00 * 1 1 4 sort CENTCENT 296.00 156.00 276.00 152.00 296.00 152.00 316.00 152.00 * 1 1 5 dname VECTOR 304.00 196.00 296.00 176.00 * 5 0 0 CENTCENT 352.00 168.00 340.00 164.00 352.00 164.00 365.00 164.00 * 1 1 4 sort CENTCENT 352.00 156.00 338.00 152.00 352.00 152.00 367.00 152.00 * 1 1 5 floor VECTOR 340.00 196.00 352.00 176.00 * 5 0 0 VECTOR 352.00 148.00 352.00 132.00 * 5 0 0 CENTCENT 352.00 124.00 339.00 120.00 352.00 120.00 366.00 120.00 * 1 1 4 scan CENTCENT 352.00 112.00 326.00 108.00 352.00 108.00 379.00 108.00 * 1 1 5 WATER VECTOR 296.00 144.00 296.00 104.00 * 5 0 0 CENTCENT 308.00 96.00 278.00 92.00 308.00 92.00 338.00 92.00 * 1 1 9 indexscan CENTCENT 296.00 84.00 277.00 80.00 296.00 80.00 315.00 80.00 * 1 1 4 DEPT CENTCENT 408.00 204.00 396.00 200.00 408.00 200.00 421.00 200.00 * 1 1 4 sort CENTCENT 408.00 192.00 394.00 188.00 408.00 188.00 422.00 188.00 * 1 1 4 dept VECTOR 392.00 228.00 408.00 212.00 * 5 0 0 VECTOR 408.00 180.00 408.00 168.00 * 5 0 0 CENTCENT 408.00 160.00 395.00 156.00 408.00 156.00 422.00 156.00 * 1 1 4 scan CENTCENT 408.00 148.00 393.00 144.00 408.00 144.00 423.00 144.00 * 1 1 3 EMP CENTCENT 296.00 72.00 277.00 68.00 296.00 68.00 316.00 68.00 * 1 1 7 (floor) CENTCENT 48.00 180.00 24.00 176.00 48.00 176.00 73.00 176.00 * 1 1 7 primary CENTCENT 44.00 164.00 28.00 160.00 44.00 160.00 61.00 160.00 * 1 1 5 index CENTCENT 44.00 152.00 37.00 148.00 44.00 148.00 52.00 148.00 * 1 1 2 on CENTCENT 44.00 136.00 25.00 132.00 44.00 132.00 63.00 132.00 * 1 1 4 DEPT CENTCENT 44.00 124.00 30.00 120.00 44.00 120.00 59.00 120.00 * 1 1 5 floor CENTCENT 48.00 196.00 38.00 192.00 48.00 192.00 58.00 192.00 * 3 1 3 (2) -1